home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Technotools
/
Technotools (Chestnut CD-ROM)(1993).ISO
/
lantools
/
l3np9
/
np_read.me
< prev
next >
Wrap
Text File
|
1990-08-02
|
7KB
|
149 lines
Date: 8-03-90
Time: 8:00 am
from the desk of Lonnie J. Rolland:
Please find enclosed a "SHAREWARE" version, full featured call logger.
It uses DBase III compatable .dbfs and .dbt
*********************************************************************
*** ATTENTION USER ***
*** It runs on a network with full record/file locking, therefore ***
*** you MUST run dos's SHARE program first before the logger! ***
*** The locking is done with netbios calls. ***
*** It'll still work fine if you don't have a network too. ***
*** ***
*** You MUST have a environment variable called 'netdrive'. ***
*** Tell logger what drive the data sits on with 'set netdrive=C' ***
*********************************************************************
To use the program, envoke it with the batch file called LOGGER. It will
change directory, set some environment variables, envoke dos's SHARE
for the record locking and unlocking and then finally envoke 'L3NP'.
| Logger now auto-detects whether its running on a mono or color system.
The logger program, when envoked, needs about 105k bytes of ram.
The file 'L3NP.EXE' is the main program. The file 'L3DBB.ZIP' is a set
of empty .dbf/.dbt files. The file 'L3_PDBT.EXE' is a packer for the memo
field file.
Delete and pack the .dbf's offline with dbase. Then run the L3_PDBT
program offline to clean out orphaned memos. Note that an orphaned
memo will happen when you: 1) delete and pack out the .dbf that
points to the memo, 2) edit an existing memo and make it grow
larger in size than it was originally (512/1024/1536...etc).
The structure for L3MAIN.DBF is:
Field Field Name Type Width Dec
1 VENDOR Character 18
2 PRODUCT Character 12
3 CALLER Character 61
4 CUSTOMER Character 59
5 ADDRESS Character 67
6 CITY Character 15
7 STATE Character 5
8 ZIP Character 5
9 PHONE Character 20
10 HARDWARE Character 65
11 SOFTWARE Character 66
12 SERIALNO Character 18
13 PROBLEM Character 21
14 CLOSED Character 1
** Total ** 434
The structure for L3MEMO.DBF is:
Field Field Name Type Width Dec
1 ORIGIN Character 7
2 STARTDATE Character 8
3 STARTTIME Character 5
4 STOPDATE Character 8
5 STOPTIME Character 5
6 ELAPSETIME Character 5
7 MEMOFLD Memo 10
** Total ** 49
Logger MUST read in the configuration (text) file, LOGGER3.CFG to
setup the 19 different, separate sub/sub's that hold the working
data files. Study the batch files. Edit them to customize the menu
and data locations. You are in control of where the data is put.
You can have all 19 program selects point at one data file or to
19 separate data files.
Logger has got timer, find, browse and does date/time stamping.
| Logger will now also send the currently displayed record to the
| printer also. If you are within the find or browse function, you
| press the (O) key to send the record information out to the printer.
| If you are within the edit function, and not in the memo pad area,
| you press the (ctrl-O) key instead.
The timer (T) command starts an entry. The find (F) command is neat.
It works on: the caller name, problem, equipment, or software.
The search order is from the last record to the first record. It will
find embedded strings anywhere within the target string and is case
insensitive. The browse (B) command uses the up, down, PgUp, PgDn,
home, and end keys. Browse will remember where you were browsing
at last. You may start the timer then escape out of the entry to do
a browse or find or go to dos and return back to your started timer
entry. When you end your edit from a find or a browse, it will ask
you if you want to (maintainence mode) re-write the record back to
where it came from or (add mode) append the record as a new one to
the end of the DBF. The choose (C) command lets you select another
database to work within. The release (R) command will remove the TSR
from your memory.
| NOTE: If you began a record log in one data area, and then decide that
| the info really should go in an other area, ( and you have not closed
| the call yet to disk ) there are two ways of handling it. You can do a
| (ctrl-T) to abort the call, go to another area, and start over. Or you
| can press (ESC) to suspend the call, then go to another area, then press
| (T) to un-suspend the call and save it out in the second area.
The memo pad portion saves only what it needs to save, from a 512
bytes minimum size, to a 4096 byte maximum size, the full screen editor
understands wordstar style key strokes and it does automatic
word-wrap at end of line also!
Logger was written by me with toolboxes from Max Software Consultants
and Turbo Power. (they were a odd couple marriage)
It does and will take advantage of 2 environment variables called:
1) NETNAME 2) NETDRIVE. Netname gets plugged into originator (BY:).
Netdrive sets up the disk drive where your data will sit.
The 19 subdirectories, vendor names, and product names are setup and
read in by the configuration file, LOGGER3.CFG.
Note you DO need to use the two environment variables. They are there
to make your life easier.
I run Artisoft's Lantastic AI Netbios/NOS.
I have my data sitting on the server in 'K:\LOGGER3\xxxx.dbf'.
I have my neton batch file setting up the variables as:
'set netdrive=K'
'set netname=LONNIE'
You (for instance) can load your data in 'C:\BILLABLE\xxxx.dbf'.
Note you may need to expand your environment size beyond the default
160 bytes by placing the following in your config.sys file.
'shell c:\command.com c:\ /e:256 /p'
I will not be held responsible for your data loss or your hardware.
I am a Senior Tech Support Engineer. I gen'ed this program to
maintain our customer database (here) at work.
KNOWN BUG LIST:
( I thought that would get your attention. )
1.) The file 'LOGGER3.CFG' must be made 'READ-ONLY' if multible
people are reading it (concurrently opening the file). This is
exactly what happens when you run it on a network.
2.) In the menu, if you select a data sub/sub that does not exist
(because you didn't create it). The program will error and
unload itself from memory.
3.)
I want your feedback! Call my company BBS and drop me a note.
It's number is (714) 545-7671.
<relax & enjoy>
(c) Copyright 1990, Lonnie J. Rolland, Symbol/MSI, Costa Mesa, CA